FO_MPI_Qualifier
This table allows for the definition of MPI qualifier codes. Each MPI qualifier code represents an external system identifier (ID) that defines a unique ID for that system. Essentially it represents the HL7 assignment authority concept.
Each record in this table represents a single MPI qualifier code. Typical use of this table is to create a system ID for each EMR and HIS system that will send data through the FASTdata concentrator interfaces.
The MPI qualifier code is used by several logic rule sets in the system. The FO_MPI table is the central patient cross reference table where an MPI Qualifier Code is cross referenced to outside patient IDs. The FO_IF_Translations table allows the user to translate external parameter, or maintenance, values based on qualifier code values.
| Field | Type | Notes |
|---|---|---|
|
MPI_Qualifier_ID |
int |
ID field, a counter. Unique |
|
Qualifier |
varchar(50) |
Enter a unique qualifier code. |
|
EntryGroupCode |
varchar(50) |
Entry group code if one is assigned to this qualifier. Enter a valid group code. |
|
Description |
varchar(255) |
Name or description of this qualifier code. |
|
DefaultProviderCode |
varchar(50) |
Default provider code if an external entry is received and a cross reference is not found in the FO_IF_Translations table. Enter a valid provider code. |
|
DefaultClientCode |
varchar(50) |
Default client code if an external entry is received and a cross reference is not found in the FO_IF_Translations table. Enter a valid client ID. |
|
DefaultPtLocCode |
varchar(50) |
Default patient location code if an external entry is received and a cross reference is not found in the FO_IF_Translations table. Enter a valid patient location code. |
|
DefaultInsuranceCode |
varchar(50) |
Default insurance code if an external entry is received and a cross reference is not found in the FO_IF_Translations table. Enter a valid insurance code. |
|
DefaultTestCode |
varchar(50) |
Default test code if an external entry is received and a cross reference is not found in the FO_IF_Translations table. Enter a valid test code. |
|
DefaultBillToCode |
varchar(50) |
Default bill to long code if an external entry is received and a cross reference is not found in the FO_IF_Translations table. Enter a valid bill to long code. Valid long codes are: Client Your Office Insurance Skilled Nursing Worker's Comp. Insurance (Non Skilled) Medicare A (Skilled) Auto Accident Not Specified Patient/Guarantor Cash Payment No Charge Skilled Nursing Auto Accident |
|
DoNotAllowEditPtLoc |
bit |
Bit field to determine if patient location code can be edited for this MPI Qualifier. Enter 0 or 1 0 = allow edit of patient location on the order screen 1 = do not allow edit of patient location on the order screen |
|
CreateDate |
datetime |
Date record was created. Informational |
|
EditDate |
datetime |
Date record was edited. Informational |
|
EditUserName |
varchar(50) |
User who created record. Informational |
|
SendProviderOnInterface |
bit |
Informational (any more info to add here?) |
|
RequiresExternalEpisodeID |
bit |
Bit field to determine if external episode ID is required for this MPI Qualifier. Enter 0 or 1 0 = external episode ID is not required 1 = external episode ID is required Works with permission chkmpireqcv [Orders Module]. |
|
UseForCDCOutboundProcessing |
bit |
Bit field to determine if CDC Outbound processing is used for this MPI Qualifier. Enter 0 or 1 0 = do not use CDC Outbound processing 1 = use CDC )utbound processing Client-level definitions are defined in the FO_CDC_Outbound_Filter table. |
|
MPIType |
varchar(50) |
Informational (any more info to add here?) |
|
RequiresClientPtID |
bit |
Bit field to determine if ClientPtId, the Clnt Pt ID field, on the order screen is required for this MPI Qualifier. Enter 0 or 1 0 = ClientPtId is not required 1 = ClientPtId is required |
|
DoNotAllowEditProvCode |
bit |
Bit field to determine if provider code can be edited for this MPI Qualifier. Enter 0 or 1 0 = allow edit of provider code on order screen 1 = do not allow edit of provider code on order screen if field is populated If this value is 1 and if the provider code is blank on the order screen, user can enter and modify a provider code and save the record. Once the record has been saved, no additional edits can be made to the provider code on the order screen. |
|
DoNotAllowEditClientCode |
bit |
Bit field to determine if client ID can be edited for this MPI Qualifier. Enter 0 or 1 0 = allow edit of client ID on order screen 1 = do not allow edit of client ID on order screen if field is populated If this value is 1 and if the client ID is blank on the order screen, user can enter and modify a client ID and save the record. Once the record has been saved, no additional edits can be made to the client ID on the order screen. |
|
DoNotAllowEditClientPtID |
bit |
Bit field to determine if ClientPtId, the Clnt Pt ID field, can be edited for this MPI Qualifier. Enter 0 or 1 0 = allow edit of ClientPtId on order screen 1 = do not allow edit of ClientPtId on order screen if field is populated If this value is 1 and if the field is blank on the order screen, user can enter and modify a ClientPtId and save the record. Once the record has been saved, no additional edits can be made to the ClientPtId on the order screen. |
|
DoNotAllowEditExternalEpisodeID |
bit |
Bit field to determine if ExternalEpisodeId can be edited for this MPI Qualifier. Enter 0 or 1 0 = allow edit of ExternalEpisodeId on order screen 1 = do not allow edit of ExternalEpisodeId on order screen if field is populated If this value is 1 and if the field is blank on the order screen, user can enter and modify an ExternalEpisodeId and save the record. Once the record has been saved, no additional edits can be made to the ExternalEpisodeId on the order screen. |
|
RequiresReqID |
bit |
Bit field to determine if ReqId, requisition ID, is required for this MPI Qualifier. Enter 0 or 1 0 = ReqId is not required 1 = ReqId is required |
|
DoNotAllowEditReqID |
bit |
Bit field to determine if ReqID can be edited for this MPI Qualifier. Enter 0 or 1 0 = allow edit of ReqID on order screen 1 = do not allow edit of ReqID on order screen if field is populated If this value is 1 and if the field is blank on the order screen, user can enter and modify a ReqID and save the record. Once the record has been saved, no additional edits can be made to the ReqID on the order screen. |
|
UpdatePatientExternalVisits |
bit |
Bit field to determine if Patient External Visits table, FO_Patient_External_Visits, is updated for this MPI Qualifier. Enter 0 or 1 0 = do not update Patient External Visit Table 1 = update Patient External Visit Table |
|
ExcludeFromMPIPtMatching |
bit |
Bit field to determine if MPI Qualifier is excluded from patient matching. Enter 0 or 1 0 = use in patient matching 1 = exclude from patient matching Future Use |
|
ReTriggerODCResultsPrecedingOrder |
bit |
Bit field to determine if ODC result messages is retriggered if it originally was sent before order messages. Enter 0 or 0 = result messages are not retriggered 1 = result messages are retriggered if order message was sent after initial result message |
|
PreserveCollDatePtPresents |
bit |
Bit field to determine if MPI Qualifier should preserve the collection date in message the first time a TDC/CDC order is opened, when processed in patient presents workflow. Enter 0 or 1 0 = do not preserve collection date 1 = preserve collection date |
|
PreserveCollDateSpecPresents |
bit |
Bit field to determine if MPI Qualifier should preserve the collection date in message the first time a TDC/CDC order is opened, when processed in specimen presents workflow. Enter 0 or 1 0 = do not preserve collection date 1 = preserve collection date |
|
SendForeignOBR2OnLISOutbound |
bit |
Bit field to determine if MPI Qualifier should send foreign OBR2 value in LIS Outbound interface. Enter 0 or 1 0 = do not send foreign OBR2 value 1 = send foreign OBR2 value |
|
UsePtLocFromExtVisits |
bit |
Bit field to determine if MPI Qualifier uses the patient location from external visits. Enter 0 or 1 0 = do not use patient location from external visits 1 = use patient location from external visits |
|
ICD9CodingMethod |
varchar(50) |
*** NEED DEFINITION *** |
|
ICD10CodingMethod |
varchar(50) |
*** NEED DEFINITION *** |
|
RequireProvNPIonSubstitution |
bit |
Instructs interfaces to use Provider NPI codes on SWAP logic. |
|
TimeZone |
varchar(50) |
*** NEED DEFINITION *** |
|
ApplyParentFillerIdsToAutoOrders |
bit |
*** NEED DEFINITION *** |
|
SourceSystemFacilityID |
varchar(50) |
Source system facility ID or HID. Enter a valid facility ID or HID. Helps discriminate an order by the HID from which it originates. |